/*
 Navicat Premium Data Transfer

 Source Server         : root
 Source Server Type    : MySQL
 Source Server Version : 80019
 Source Host           : localhost:3306
 Source Schema         : voldb

 Target Server Type    : MySQL
 Target Server Version : 80019
 File Encoding         : 65001

 Date: 03/03/2021 17:12:02
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for v_blog
-- ----------------------------
DROP TABLE IF EXISTS `v_blog`;
CREATE TABLE `v_blog` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `title` varchar(255) DEFAULT NULL COMMENT '博客标题',
  `content` longtext COMMENT '博客内容',
  `first_picture` varchar(255) DEFAULT NULL COMMENT '博客首图',
  `description` varchar(255) DEFAULT NULL COMMENT '博客描述',
  `flag` varchar(255) DEFAULT NULL COMMENT '标签',
  `views` int DEFAULT '0' COMMENT '浏览次数',
  `like` bigint DEFAULT '0' COMMENT '被喜欢的次数',
  `appreciative` bit(1) DEFAULT NULL COMMENT '是否赞赏',
  `commentable` bit(1) DEFAULT NULL COMMENT '是否评论',
  `recommendable` bit(1) DEFAULT NULL COMMENT '是否推荐',
  `published` bit(1) DEFAULT NULL COMMENT '发布状态',
  `share_statement` bit(1) DEFAULT NULL COMMENT '版权',
  `type_id` bigint DEFAULT NULL COMMENT '类型ID',
  `user_id` bigint DEFAULT NULL COMMENT '属主ID',
  `version` int NOT NULL DEFAULT '1' COMMENT '乐观锁',
  `deleted` int NOT NULL DEFAULT '0' COMMENT '逻辑删除',
  `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `FK_blog_type` (`type_id`),
  KEY `FK_blog_user` (`user_id`),
  CONSTRAINT `FK_blog_type` FOREIGN KEY (`type_id`) REFERENCES `v_type` (`id`),
  CONSTRAINT `FK_blog_user` FOREIGN KEY (`user_id`) REFERENCES `v_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of v_blog
-- ----------------------------
BEGIN;
INSERT INTO `v_blog` VALUES (1, 'z', 'xx', 'https://tva1.sinaimg.cn/large/007S8ZIlgy1ghyjdm97r7j30go09ewk1.jpg', 'x', '原创', 3, 1, b'1', b'0', b'1', b'1', b'0', 3, 1, 1, 0, '2020-08-23 23:34:55', '2020-08-27 00:38:27');
INSERT INTO `v_blog` VALUES (2, 'z', 's', 'https://tva1.sinaimg.cn/large/007S8ZIlgy1ghyjdm97r7j30go09ewk1.jpg', 's', '原创', 4, 1, NULL, b'0', NULL, b'1', b'1', 10, 1, 1, 0, '2020-08-23 23:34:55', '2020-10-23 20:31:57');
INSERT INTO `v_blog` VALUES (3, 'z3', 'k', 'https://tva1.sinaimg.cn/large/007S8ZIlgy1ghyjdm97r7j30go09ewk1.jpg', 'zzz', '原创', 110, 1, NULL, b'0', NULL, b'1', NULL, 4, 1, 1, 0, '2021-08-23 23:34:55', '2021-03-03 16:55:04');
INSERT INTO `v_blog` VALUES (4, 'z4', 'x', 'https://tva1.sinaimg.cn/large/007S8ZIlgy1ghyjdm97r7j30go09ewk1.jpg', 'x', '原创', 3, 1, NULL, b'1', NULL, NULL, NULL, 3, 1, 1, 0, '2020-08-23 23:34:55', '2020-08-27 00:46:29');
INSERT INTO `v_blog` VALUES (5, 'z52', 'xdddd', 'https://tva1.sinaimg.cn/large/007S8ZIlgy1ghyjdm97r7j30go09ewk1.jpg', 'x', '原创', 2, 1, NULL, b'1', NULL, b'1', NULL, 2, 1, 1, 0, '2019-08-23 23:34:55', '2020-08-28 04:26:52');
INSERT INTO `v_blog` VALUES (6, 'z123', 'xwo你们', 'https://tva1.sinaimg.cn/large/007S8ZIlgy1ghyjdm97r7j30go09ewk1.jpg', 'w', '原创', 560, 90, b'1', b'1', b'1', b'1', b'1', 1, 1, 1, 0, '2020-08-26 15:58:31', '2021-03-03 16:55:11');
INSERT INTO `v_blog` VALUES (7, 'zzzzzzz', 'x', 'https://tva1.sinaimg.cn/large/007S8ZIlgy1ghyjdm97r7j30go09ewk1.jpg', 'x', '原创', 4, 1, NULL, b'1', NULL, NULL, NULL, 2, 1, 1, 0, '2019-08-26 19:24:54', '2020-08-28 04:09:38');
INSERT INTO `v_blog` VALUES (8, 'z', 'efesdcscdscsdcsd', 'https://tva1.sinaimg.cn/large/007S8ZIlgy1ghyjdm97r7j30go09ewk1.jpg', 'z', '原创', 8, 9, NULL, b'1', NULL, b'1', NULL, 1, 1, 1, 0, '2020-08-26 19:42:45', '2020-09-02 20:37:58');
INSERT INTO `v_blog` VALUES (9, 'www', 'ww', 'https://tva1.sinaimg.cn/large/007S8ZIlgy1ghyjdm97r7j30go09ewk1.jpg', 'www', '原创', 0, 1, NULL, b'1', NULL, b'1', NULL, 1, 1, 1, 0, '2019-08-26 19:45:33', '2020-08-28 02:31:33');
INSERT INTO `v_blog` VALUES (10, 'gggggggggggg', 'cxxxwxw', 'https://tva1.sinaimg.cn/large/007S8ZIlgy1ghyjdm97r7j30go09ewk1.jpg', 'cwxx', '转载', 4, 8, NULL, b'1', b'1', b'1', NULL, 2, 1, 1, 0, '2020-08-26 19:59:58', '2020-09-02 20:24:39');
INSERT INTO `v_blog` VALUES (11, 'ggg', 'cs', 'https://tva1.sinaimg.cn/large/007S8ZIlgy1ghyjdm97r7j30go09ewk1.jpg', 'c', '原创', 1, 1, NULL, b'1', NULL, b'1', NULL, 1, 1, 1, 1, '2021-08-26 20:08:31', '2020-08-28 04:27:17');
INSERT INTO `v_blog` VALUES (12, 'wo', 'wo', 'https://tva1.sinaimg.cn/large/007S8ZIlgy1ghyjdm97r7j30go09ewk1.jpg', '谁', '原创', 21, 8, b'1', b'0', b'1', b'1', NULL, 1, 1, 1, 0, '2020-08-27 00:21:34', '2020-10-23 20:30:55');
INSERT INTO `v_blog` VALUES (13, 'wwwww', 'w', 'https://tva1.sinaimg.cn/large/007S8ZIlgy1ghyjdm97r7j30go09ewk1.jpg', 'wdwxasxccs', '原创', 1, 2, NULL, b'1', NULL, b'1', NULL, 3, 1, 1, 0, '2020-08-27 00:27:48', '2020-09-02 20:27:31');
INSERT INTO `v_blog` VALUES (14, 'test', 'ASRDS', 'https://tva1.sinaimg.cn/large/007S8ZIlgy1ghyjdm97r7j30go09ewk1.jpg', 'x x x\r\n', '原创', 0, 1, NULL, b'1', NULL, b'1', NULL, 4, 1, 1, 0, '2020-08-27 00:32:45', '2020-08-27 00:35:44');
INSERT INTO `v_blog` VALUES (15, 'jojo', 'ogog', 'https://tva1.sinaimg.cn/large/007S8ZIlgy1ghyjdm97r7j30go09ewk1.jpg', 'ddddd', '原创', 0, 1, NULL, b'1', NULL, b'1', NULL, 9, 1, 1, 0, '2020-08-27 00:35:30', '2020-08-27 00:38:27');
INSERT INTO `v_blog` VALUES (16, 's1', 'w', 's', 's', '原创', 0, 0, NULL, b'1', NULL, b'1', NULL, 1, 1, 1, 1, '2020-08-28 04:19:16', '2020-08-28 04:19:19');
INSERT INTO `v_blog` VALUES (17, 'Java编程练习题', '# Java编程练习题\r\n\r\nhttps://gitee.com/iozxc/hnie-java-2018\r\n\r\n#### 介绍\r\n\r\n代码在`src/com/volcreate/week$`里，\r\n提交时去掉:\r\n\r\n```java\r\n package com.volcreate.week$;\r\n```\r\n\r\n主要提交:\r\n\r\n```java\r\nimport xxx;\r\npublic class Main {\r\n    public static void main(String[] args) {\r\n        // ...\r\n    }\r\n}\r\n```\r\n\r\n湖南工程学院2018java编程练习题:\r\nhttps://pintia.cn/\r\n\r\n', 'https://t8.baidu.com/it/u=3571592872,3353494284&fm=79&app=86&size=h300&n=0&g=4n&f=jpeg?sec=1601379000&t=1ccaa66aff67d334a2dd1cc9bd52d72d', 'ssssssssss', '原创', 2, 1, b'1', b'1', b'1', b'1', b'1', 1, 1, 1, 0, '2020-09-22 19:30:17', '2020-10-23 20:32:13');
INSERT INTO `v_blog` VALUES (18, '3.3', 'as d sa', 'a s d', '啥啥啥', '原创', 1, 1, b'1', b'1', NULL, b'1', NULL, 2, 1, 1, 0, '2021-03-03 16:34:49', '2021-03-03 16:37:04');
INSERT INTO `v_blog` VALUES (19, '3.333', 'sdsdd', 'ss21', 's', '原创', 3, 0, NULL, NULL, NULL, b'1', NULL, 2, 1, 1, 0, '2021-03-03 16:35:51', '2021-03-03 16:36:57');
COMMIT;

-- ----------------------------
-- Table structure for v_blog_like
-- ----------------------------
DROP TABLE IF EXISTS `v_blog_like`;
CREATE TABLE `v_blog_like` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `ip4` varchar(20) DEFAULT NULL COMMENT 'ipv4地址',
  `ip6` varchar(130) DEFAULT NULL COMMENT 'ipv6地址',
  `last_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次点击喜欢的时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of v_blog_like
-- ----------------------------
BEGIN;
INSERT INTO `v_blog_like` VALUES (6, '0:0:0:0:0:0:0:1', NULL, '2021-03-03 16:37:05');
INSERT INTO `v_blog_like` VALUES (8, '0:0:0:0:0:0:0:1', NULL, '2021-03-03 16:37:05');
COMMIT;

-- ----------------------------
-- Table structure for v_blog_tag
-- ----------------------------
DROP TABLE IF EXISTS `v_blog_tag`;
CREATE TABLE `v_blog_tag` (
  `blog_id` bigint NOT NULL,
  `tag_id` bigint NOT NULL,
  `deleted` int NOT NULL DEFAULT '0' COMMENT '逻辑删除',
  KEY `FK_blog_id` (`blog_id`),
  KEY `FK_tag_id` (`tag_id`),
  CONSTRAINT `FK_blog_id` FOREIGN KEY (`blog_id`) REFERENCES `v_blog` (`id`),
  CONSTRAINT `FK_tag_id` FOREIGN KEY (`tag_id`) REFERENCES `v_tag` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of v_blog_tag
-- ----------------------------
BEGIN;
INSERT INTO `v_blog_tag` VALUES (9, 2, 0);
INSERT INTO `v_blog_tag` VALUES (9, 5, 0);
INSERT INTO `v_blog_tag` VALUES (1, 1, 0);
INSERT INTO `v_blog_tag` VALUES (1, 2, 0);
INSERT INTO `v_blog_tag` VALUES (3, 1, 0);
INSERT INTO `v_blog_tag` VALUES (3, 2, 0);
INSERT INTO `v_blog_tag` VALUES (3, 4, 0);
INSERT INTO `v_blog_tag` VALUES (3, 5, 0);
INSERT INTO `v_blog_tag` VALUES (10, 1, 0);
INSERT INTO `v_blog_tag` VALUES (10, 3, 0);
INSERT INTO `v_blog_tag` VALUES (12, 1, 0);
INSERT INTO `v_blog_tag` VALUES (13, 4, 0);
INSERT INTO `v_blog_tag` VALUES (13, 5, 0);
INSERT INTO `v_blog_tag` VALUES (14, 5, 0);
INSERT INTO `v_blog_tag` VALUES (15, 4, 0);
INSERT INTO `v_blog_tag` VALUES (2, 2, 0);
INSERT INTO `v_blog_tag` VALUES (2, 5, 0);
INSERT INTO `v_blog_tag` VALUES (17, 3, 0);
INSERT INTO `v_blog_tag` VALUES (18, 1, 0);
INSERT INTO `v_blog_tag` VALUES (19, 2, 0);
COMMIT;

-- ----------------------------
-- Table structure for v_comment
-- ----------------------------
DROP TABLE IF EXISTS `v_comment`;
CREATE TABLE `v_comment` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `content` varchar(255) DEFAULT NULL COMMENT '评论内容',
  `user_id` bigint DEFAULT NULL COMMENT '属主ID',
  `blog_id` bigint DEFAULT NULL COMMENT '博客ID',
  `parent_comment_id` bigint DEFAULT NULL COMMENT '父评论ID',
  `root_comment_id` bigint DEFAULT NULL COMMENT '根评论的ID，用于在前端展示，方便数据库操作的字段',
  `version` int NOT NULL DEFAULT '1' COMMENT '乐观锁',
  `deleted` int NOT NULL DEFAULT '0' COMMENT '逻辑删除',
  `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `FK_comment_blog` (`blog_id`),
  KEY `FK_comment_user` (`user_id`),
  KEY `FK_root_comment` (`root_comment_id`),
  KEY `FK_parent_comment` (`parent_comment_id`),
  CONSTRAINT `FK_comment_blog` FOREIGN KEY (`blog_id`) REFERENCES `v_blog` (`id`),
  CONSTRAINT `FK_comment_user` FOREIGN KEY (`user_id`) REFERENCES `v_user` (`id`),
  CONSTRAINT `FK_parent_comment` FOREIGN KEY (`parent_comment_id`) REFERENCES `v_comment` (`id`),
  CONSTRAINT `FK_root_comment` FOREIGN KEY (`root_comment_id`) REFERENCES `v_comment` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of v_comment
-- ----------------------------
BEGIN;
INSERT INTO `v_comment` VALUES (51, 'x', 4, 6, NULL, NULL, 1, 0, '2020-08-27 04:56:09', '2020-08-27 04:56:47');
INSERT INTO `v_comment` VALUES (55, '?', 2, 6, 51, 51, 1, 0, '2020-08-27 05:00:56', '2020-08-27 05:00:56');
INSERT INTO `v_comment` VALUES (57, 'zheyanga', 5, 6, NULL, NULL, 1, 0, '2020-08-27 05:02:28', '2020-08-27 05:02:28');
INSERT INTO `v_comment` VALUES (58, '你好啊', 3, 6, 55, 51, 1, 0, '2020-08-27 05:03:04', '2020-08-27 05:03:04');
INSERT INTO `v_comment` VALUES (59, '@疯狂的游客2 :你好', 5, 6, 58, 51, 1, 0, '2020-08-27 05:35:13', '2020-08-27 21:24:31');
INSERT INTO `v_comment` VALUES (60, '@疯狂的游客4 ？？', 5, 6, 59, 51, 1, 0, '2020-08-27 05:35:38', '2020-08-27 05:35:38');
INSERT INTO `v_comment` VALUES (61, '@疯狂的游客4 ？', 3, 6, 60, 51, 1, 0, '2020-08-27 05:35:45', '2020-08-27 05:35:45');
INSERT INTO `v_comment` VALUES (62, '@疯狂的游客4 : 你好', 5, 6, NULL, NULL, 1, 0, '2020-08-27 05:38:09', '2020-08-27 21:24:31');
INSERT INTO `v_comment` VALUES (63, '@疯狂的游客4 : 你好', 4, 6, 60, 51, 1, 0, '2020-08-27 21:42:47', '2020-08-27 21:42:47');
INSERT INTO `v_comment` VALUES (64, '@疯狂的游客3 :123', 2, 6, 63, 51, 1, 0, '2020-08-27 21:45:31', '2020-08-27 21:45:31');
INSERT INTO `v_comment` VALUES (65, '???', 5, 6, NULL, NULL, 1, 0, '2020-08-27 21:45:39', '2020-08-27 21:45:39');
INSERT INTO `v_comment` VALUES (66, '@疯狂的游客4 :你们是傻猪', 3, 6, 65, 65, 1, 0, '2020-08-27 21:45:46', '2020-08-27 21:45:46');
INSERT INTO `v_comment` VALUES (67, '@疯狂的游客2 :你也是', 3, 6, 66, 65, 1, 0, '2020-08-27 21:45:51', '2020-08-27 21:45:51');
INSERT INTO `v_comment` VALUES (68, '@疯狂的游客2 :你也是', 2, 6, 67, 65, 1, 0, '2020-08-27 21:45:57', '2020-08-27 21:45:57');
INSERT INTO `v_comment` VALUES (69, '@疯狂的游客1 :你也是', 2, 6, 68, 65, 1, 0, '2020-08-27 21:46:02', '2020-08-27 21:46:02');
INSERT INTO `v_comment` VALUES (70, '@孤寡老人 :hah ', 3, 6, 59, 51, 1, 0, '2020-08-27 22:04:16', '2020-08-27 22:04:16');
INSERT INTO `v_comment` VALUES (71, '@孤寡老人 :你是傻逼', 3, 6, 59, 51, 1, 0, '2020-08-27 22:06:42', '2020-08-27 22:06:42');
INSERT INTO `v_comment` VALUES (72, '@大白 :你好', 1, 6, 51, 51, 1, 0, '2020-08-27 22:11:17', '2020-08-27 22:11:17');
INSERT INTO `v_comment` VALUES (73, '@zxc :我是你粑粑', 1, 6, 72, 51, 1, 0, '2020-08-27 22:11:27', '2020-08-27 22:11:27');
INSERT INTO `v_comment` VALUES (74, '@小明 :你是谁', 1, 6, 71, 51, 1, 0, '2020-08-27 22:11:31', '2020-08-27 22:11:31');
INSERT INTO `v_comment` VALUES (75, '你们好', 1, 6, NULL, NULL, 1, 0, '2020-08-27 22:13:31', '2020-08-27 22:13:31');
INSERT INTO `v_comment` VALUES (76, '@小李 :你好', 1, 6, 69, 65, 1, 0, '2020-08-27 22:14:22', '2020-08-27 22:14:22');
INSERT INTO `v_comment` VALUES (77, 'nimenhao', 1, 6, NULL, NULL, 1, 0, '2020-08-28 01:03:41', '2020-08-28 01:03:41');
INSERT INTO `v_comment` VALUES (78, '@zxc ：你好', 1, 6, 76, 65, 1, 0, '2020-08-28 01:04:12', '2020-08-28 01:04:12');
INSERT INTO `v_comment` VALUES (79, '@小李 :nihao', 1, 6, 69, 65, 1, 0, '2020-08-28 01:04:20', '2020-08-28 01:04:20');
INSERT INTO `v_comment` VALUES (80, '@zxc :?', 1, 6, 78, 65, 1, 0, '2020-08-28 01:04:26', '2020-08-28 01:04:26');
INSERT INTO `v_comment` VALUES (81, '你们好啊', 7, 6, NULL, NULL, 1, 0, '2020-08-28 04:09:52', '2020-08-28 04:09:52');
INSERT INTO `v_comment` VALUES (82, 'ssss', 1, 17, NULL, NULL, 1, 0, '2020-09-22 19:31:57', '2020-09-22 19:31:57');
INSERT INTO `v_comment` VALUES (83, '@zxc :xxx', 1, 17, 82, 82, 1, 0, '2020-09-22 19:32:01', '2020-09-22 19:32:01');
COMMIT;

-- ----------------------------
-- Table structure for v_tag
-- ----------------------------
DROP TABLE IF EXISTS `v_tag`;
CREATE TABLE `v_tag` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(255) DEFAULT NULL COMMENT '标签名',
  `version` int NOT NULL DEFAULT '1' COMMENT '乐观锁',
  `deleted` int NOT NULL DEFAULT '0' COMMENT '逻辑删除',
  `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of v_tag
-- ----------------------------
BEGIN;
INSERT INTO `v_tag` VALUES (1, '标签11', 1, 0, '2020-08-24 15:43:10', '2020-09-02 14:39:58');
INSERT INTO `v_tag` VALUES (2, '标签2', 1, 0, '2020-08-24 15:43:16', '2020-08-24 15:43:16');
INSERT INTO `v_tag` VALUES (3, '标签3', 1, 0, '2020-08-24 15:43:30', '2020-08-24 15:43:30');
INSERT INTO `v_tag` VALUES (4, '标签4', 1, 0, '2020-08-24 15:44:41', '2020-08-24 15:44:41');
INSERT INTO `v_tag` VALUES (5, '标签5', 1, 0, '2020-08-24 15:45:25', '2020-09-02 14:40:19');
COMMIT;

-- ----------------------------
-- Table structure for v_type
-- ----------------------------
DROP TABLE IF EXISTS `v_type`;
CREATE TABLE `v_type` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(255) DEFAULT NULL COMMENT '类型名',
  `version` int NOT NULL DEFAULT '1' COMMENT '乐观锁',
  `deleted` int NOT NULL DEFAULT '0' COMMENT '逻辑删除',
  `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of v_type
-- ----------------------------
BEGIN;
INSERT INTO `v_type` VALUES (1, '1-2', 1, 0, '2020-08-23 20:52:14', '2020-09-01 22:29:54');
INSERT INTO `v_type` VALUES (2, '2-1', 1, 0, '2020-08-23 20:54:40', '2020-09-02 14:39:05');
INSERT INTO `v_type` VALUES (3, '3', 1, 0, '2020-08-23 20:54:40', '2020-09-02 14:40:30');
INSERT INTO `v_type` VALUES (4, '4', 1, 0, '2020-08-23 20:54:41', '2020-09-02 14:40:30');
INSERT INTO `v_type` VALUES (5, '5', 1, 0, '2020-08-23 20:54:41', '2020-09-02 14:40:30');
INSERT INTO `v_type` VALUES (6, '6', 1, 0, '2020-08-23 20:54:41', '2020-09-02 14:40:30');
INSERT INTO `v_type` VALUES (7, '7', 1, 0, '2020-08-23 20:54:41', '2020-09-02 14:40:30');
INSERT INTO `v_type` VALUES (8, '8', 1, 0, '2020-08-23 20:54:41', '2020-09-02 14:40:30');
INSERT INTO `v_type` VALUES (9, '9', 1, 0, '2020-08-24 04:25:29', '2020-09-02 14:40:30');
INSERT INTO `v_type` VALUES (10, '10-9', 1, 0, '2020-08-24 04:28:46', '2020-09-01 22:23:13');
INSERT INTO `v_type` VALUES (11, '11', 1, 0, '2020-08-31 22:55:12', '2020-09-01 21:32:23');
INSERT INTO `v_type` VALUES (12, '12', 1, 0, '2020-08-31 22:55:46', '2020-09-01 21:32:23');
INSERT INTO `v_type` VALUES (13, '13', 1, 0, '2020-08-31 22:57:10', '2020-09-01 21:32:22');
INSERT INTO `v_type` VALUES (14, '14', 1, 0, '2020-08-31 23:00:29', '2020-09-01 21:32:23');
INSERT INTO `v_type` VALUES (15, '15', 1, 0, '2020-08-31 23:00:40', '2020-09-02 14:40:30');
INSERT INTO `v_type` VALUES (16, '16', 1, 0, '2020-08-31 23:03:43', '2020-09-01 21:32:22');
INSERT INTO `v_type` VALUES (17, 'vue1', 1, 0, '2020-08-31 23:08:10', '2020-09-01 21:39:38');
INSERT INTO `v_type` VALUES (18, 'vue2', 1, 0, '2020-08-31 23:08:16', '2020-09-01 21:35:36');
COMMIT;

-- ----------------------------
-- Table structure for v_user
-- ----------------------------
DROP TABLE IF EXISTS `v_user`;
CREATE TABLE `v_user` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `avatar` varchar(255) DEFAULT NULL COMMENT '创建时间',
  `email` varchar(255) DEFAULT NULL COMMENT '用户邮箱',
  `nickname` varchar(255) DEFAULT NULL COMMENT '用户昵称',
  `type` int DEFAULT NULL COMMENT '用户类型',
  `username` varchar(255) DEFAULT NULL COMMENT '用户登录名',
  `password` varchar(255) DEFAULT NULL COMMENT '用户密码',
  `version` int NOT NULL DEFAULT '1' COMMENT '乐观锁',
  `deleted` int NOT NULL DEFAULT '0' COMMENT '逻辑删除',
  `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of v_user
-- ----------------------------
BEGIN;
INSERT INTO `v_user` VALUES (1, '/images/avatar/a1.jpeg', 'xinchenzhou666@gmail.com', 'zxc', 1, 'admin', '123456', 1, 0, '2020-08-23 19:38:32', '2021-03-03 16:31:31');
INSERT INTO `v_user` VALUES (2, '/images/avatar/user-2.png', NULL, '小李', 10, '', '', 1, 0, '2020-08-23 19:39:55', '2020-08-27 21:55:25');
INSERT INTO `v_user` VALUES (3, '/images/avatar/user-3.png', NULL, '小明', 10, '', '', 1, 0, '2020-08-23 19:40:52', '2020-08-27 21:55:25');
INSERT INTO `v_user` VALUES (4, '/images/avatar/user-4.png', NULL, '大白', 10, '', '', 1, 0, '2020-08-23 19:43:19', '2020-08-27 21:55:25');
INSERT INTO `v_user` VALUES (5, '/images/avatar/user-5.png', NULL, '孤寡老人', 10, '', '', 1, 0, '2020-08-23 19:50:37', '2020-08-27 21:55:25');
INSERT INTO `v_user` VALUES (6, '/images/avatar/user-6.png', NULL, '活泼的兔子', 10, '', NULL, 1, 0, '2020-08-27 21:55:25', '2020-08-27 21:55:25');
INSERT INTO `v_user` VALUES (7, '/images/avatar/user-7.png', NULL, '呆逼的傻子', 10, '', NULL, 1, 0, '2020-08-27 21:55:25', '2020-08-27 21:55:25');
INSERT INTO `v_user` VALUES (8, '/images/avatar/user-8.png', NULL, '活泼乱跳的匿名者', 10, '', NULL, 1, 0, '2020-08-27 21:55:25', '2020-08-27 21:55:25');
INSERT INTO `v_user` VALUES (9, '/images/avatar/user-9.png', NULL, '一位不愿意透露姓名的神秘人', 10, '', NULL, 1, 0, '2020-08-27 21:55:25', '2020-08-27 21:55:25');
INSERT INTO `v_user` VALUES (10, '/images/avatar/a1.jpeg', '1269670415@qq.com', '201803010224_周鑫晨_计科1802', 5, 'admin2', '123456', 1, 0, '2020-09-28 21:20:33', '2021-03-03 16:31:31');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
